package nivalsoul.kettle.plugins.test;

import cn.hutool.core.io.FileUtil;
import cn.hutool.core.math.MathUtil;
import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONObject;
import com.google.common.collect.Sets;
import nivalsoul.kettle.plugins.util.excel.HutoolExcelUtil;
import org.apache.commons.math3.util.MathUtils;

import java.io.File;
import java.util.HashSet;
import java.util.List;
import java.util.Set;

/**
 * @Author 空山苦水禅人
 * @Date 2020/11/11 8:52
 */
public class A {
    public static void main(String[] args) {
        /*String fields = "#文件开始#软件厂家标志#客货本补#车次#车站号#副司机号#总重#辆数#计长#载重#车速等级#车号#车型#LKJ装置号#车速等级2#车次2#客货本补2#客货本补3#载重2#总重2#辆数2#计长2#车速等级3#副司机号2#车站号2";
        String values = "@@@2021-02-09@@@株洲所@@@货本@@@55002@@@32柳村南@@@2620731王德宝@@@4206@@@210@@@235.0@@@0@@@null@@@271A节@@@HXD1@@@7165@@@null@@@货本55002@@@货本@@@货本@@@0@@@4206@@@210@@@235.0@@@null@@@2620731王德宝@@@32柳村南";

        String[] fa = fields.substring(1).split("#");
        String[] va = values.substring(3).split("@@@");
        for (int i = 0; i < fa.length; i++) {
            System.out.println(fa[i]+"==="+va[i]);
        }*/

       /* String filename = "D:\\20211119_071007.xlsx";
        int sheetNum = 2;
        List<List<String>> lists = new HutoolExcelUtil().readExcel(filename, sheetNum);

        System.out.println(lists);*/
        
        String file = "D:\\t2.xlsx";
        List<List<String>> lists = new HutoolExcelUtil().readExcel(file, 0);
        
        System.out.println(lists);
    }
}
